Most of the work of database is done by SQL. As an example below SQL statement fan-out all record from Student table.
SELECT *FROM student
SQL statement is not case sensitive. We can use this statement like ?select *from student?. It will show same result.
There are two types of SQL statement like DDL and DDM.
DDL- Data Definition Language:
These part contain create, alter, delete database etc statement. To define index(keys) for creating relationship between tables. Important DDL Statements are given below?
CREATE DATABASE - for a new database ALTER DATABASE - alter a database CREATE TABLE - creates a new table ALTER TABLE -edit a table DROP TABLE - remove a table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index DML-Data Manipulation Language: SELECT - extracts data from a database UPDATE - updates data in a database DELETE - deletes data from a database INSERT INTO - inserts new data into a database
